MANGO: annexure-IX
DISCOUNTED CASHFLOW STATEMENT
(Rs. in thousand)
Particulars |
Year I |
Year II |
Year III |
Year IV |
Year V |
Year VI |
Year VII |
Year VIII |
Year IX |
Year X |
Year XI |
Year XII |
Year XIII |
Year XIV |
Year XV |
Total |
Capital
Cost |
150.00 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Gross
Revenue |
50.00 |
60.00 |
70.00 |
70.00 |
70.00 |
70.00 |
70.00 |
70.00 |
70.00 |
70.00 |
70.00 |
70.00 |
70.00 |
70.00 |
70.00 |
|
Prod &
Other Costs |
24.50 |
25.60 |
26.70 |
26.70 |
26.70 |
26.70 |
26.70 |
26.70 |
26.70 |
26.70 |
26.70 |
26.70 |
26.70 |
26.70 |
26.70 |
|
Salvage
Value |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Gross Surplus |
-124.50 |
34.40 |
43.30 |
43.30 |
43.30 |
43.30 |
43.30 |
43.30 |
43.30 |
43.30 |
43.30 |
43.30 |
43.30 |
43.30 |
91.00 |
|
DF @ 15% |
0.870 |
0.756 |
0.658 |
0.572 |
0.497 |
0.432 |
0.376 |
0.327 |
0.284 |
0.247 |
0.215 |
0.187 |
0.163 |
0.141 |
0.123 |
|
PW @ 15% |
-108.30 |
26.00 |
28.50 |
24.80 |
21.50 |
18.70 |
16.30 |
14.20 |
12.30 |
10.70 |
9.30 |
8.10 |
7.00 |
6.10 |
11.20 |
64.67 |
DF @ 30% |
0.769 |
0.592 |
0.455 |
0.350 |
0.269 |
0.234 |
0.204 |
0.177 |
0.154 |
0.134 |
0.116 |
0.101 |
0.088 |
0.077 |
0.067 |
|
PW @ 30% |
-95.80 |
20.40 |
19.70 |
15.20 |
11.70 |
10.10 |
8.80 |
7.70 |
6.70 |
5.80 |
5.00 |
4.40 |
3.80 |
3.30 |
6.10 |
10.21 |
IIR |
|
32.59 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DF @ 11% |
0.901 |
0.812 |
0.731 |
0.659 |
0.593 |
0.535 |
0.482 |
0.434 |
0.391 |
0.352 |
0.317 |
0.286 |
0.258 |
0.232 |
0.209 |
|
PW of Operational Cash flow |
23.00 |
27.90 |
31.70 |
28.50 |
25.70 |
23.10 |
20.90 |
18.80 |
16.90 |
15.20 |
13.70 |
12.40 |
11.20 |
10.00 |
9.00 |
288.11 |
NPV of Operational
Cash flow |
288.10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Initial
Investment |
150.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Benefit
Cost Ratio |
1.90 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|